Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	35753
Missing cells	763
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.0 MiB
Average record size in memory	441.3 B

Variable types

Categorical	6
Numeric	8

Alerts

`district` has a high cardinality: 80 distinct values	High cardinality
`site_code` has a high cardinality: 155 distinct values	High cardinality
`stock_initial` is highly overall correlated with `stock_distributed` and 2 other fields	High correlation
`stock_distributed` is highly overall correlated with `stock_initial` and 1 other fields	High correlation
`stock_end` is highly overall correlated with `stock_initial` and 1 other fields	High correlation
`average_monthly_consumption` is highly overall correlated with `stock_initial` and 2 other fields	High correlation
`region` is highly overall correlated with `district` and 1 other fields	High correlation
`district` is highly overall correlated with `region` and 1 other fields	High correlation
`site_type` is highly overall correlated with `region` and 1 other fields	High correlation
`stock_ordered` has 763 (2.1%) missing values	Missing
`stock_adjustment` is highly skewed (γ1 = 23.37625509)	Skewed
`stock_ordered` is highly skewed (γ1 = 39.96661947)	Skewed
`stock_initial` has 12431 (34.8%) zeros	Zeros
`stock_received` has 29360 (82.1%) zeros	Zeros
`stock_distributed` has 17738 (49.6%) zeros	Zeros
`stock_adjustment` has 34013 (95.1%) zeros	Zeros
`stock_end` has 11976 (33.5%) zeros	Zeros
`average_monthly_consumption` has 13191 (36.9%) zeros	Zeros
`stock_ordered` has 21552 (60.3%) zeros	Zeros

Reproduction

Analysis started	2023-09-02 16:39:59.330774
Analysis finished	2023-09-02 16:40:07.922186
Duration	8.59 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

year
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

2018	11192
2017	10356
2016	8031
2019	6174

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	143012
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019
2nd row	2019
3rd row	2019
4th row	2019
5th row	2019

Common Values

Value	Count	Frequency (%)
2018	11192	31.3%
2017	10356	29.0%
2016	8031	22.5%
2019	6174	17.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2018	11192	31.3%
2017	10356	29.0%
2016	8031	22.5%
2019	6174	17.3%

Most occurring characters

Value	Count	Frequency (%)
2	35753	25.0%
0	35753	25.0%
1	35753	25.0%
8	11192	7.8%
7	10356	7.2%
6	8031	5.6%
9	6174	4.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	143012	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	35753	25.0%
0	35753	25.0%
1	35753	25.0%
8	11192	7.8%
7	10356	7.2%
6	8031	5.6%
9	6174	4.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	143012	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	35753	25.0%
0	35753	25.0%
1	35753	25.0%
8	11192	7.8%
7	10356	7.2%
6	8031	5.6%
9	6174	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	143012	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	35753	25.0%
0	35753	25.0%
1	35753	25.0%
8	11192	7.8%
7	10356	7.2%
6	8031	5.6%
9	6174	4.3%

month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.1694124

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	558.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4290791
Coefficient of variation (CV)	0.5558194
Kurtosis	-1.1732673
Mean	6.1694124
Median Absolute Deviation (MAD)	3
Skewness	0.16188637
Sum	220575
Variance	11.758583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	3459	9.7%
5	3439	9.6%
4	3427	9.6%
3	3355	9.4%
2	3223	9.0%
1	3222	9.0%
12	2695	7.5%
11	2677	7.5%
10	2628	7.4%
9	2586	7.2%
Other values (2)	5042	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3222	9.0%
2	3223	9.0%
3	3355	9.4%
4	3427	9.6%
5	3439	9.6%
6	3459	9.7%
7	2492	7.0%
8	2550	7.1%
9	2586	7.2%
10	2628	7.4%

Value	Count	Frequency (%)
12	2695	7.5%
11	2677	7.5%
10	2628	7.4%
9	2586	7.2%
8	2550	7.1%
7	2492	7.0%
6	3459	9.7%
5	3439	9.6%
4	3427	9.6%
3	3355	9.4%

region
Categorical

Distinct	20
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

ABIDJAN 2	6504
ABIDJAN 1-GRANDS PONTS	4597
AGNEBY-TIASSA-ME	2389
PORO-TCHOLOGO-BAGOUE	2319
GBOKLE-NAWA-SAN PEDRO	2266
Other values (15)	17678

Length

Max length	23
Median length	20
Mean length	13.891366
Min length	3

Characters and Unicode

Total characters	496658
Distinct characters	29
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INDENIE-DJUABLIN
2nd row	INDENIE-DJUABLIN
3rd row	INDENIE-DJUABLIN
4th row	INDENIE-DJUABLIN
5th row	INDENIE-DJUABLIN

Common Values

Value	Count	Frequency (%)
ABIDJAN 2	6504	18.2%
ABIDJAN 1-GRANDS PONTS	4597	12.9%
AGNEBY-TIASSA-ME	2389	6.7%
PORO-TCHOLOGO-BAGOUE	2319	6.5%
GBOKLE-NAWA-SAN PEDRO	2266	6.3%
N'ZI-IFOU-MORONOU	2132	6.0%
BELIER	1625	4.5%
BOUNKANI-GONTOUGO	1593	4.5%
SUD-COMOE	1491	4.2%
HAUT-SASSANDRA	1295	3.6%
Other values (10)	9542	26.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
abidjan	11101	20.7%
2	6504	12.1%
1-grands	4597	8.6%
ponts	4597	8.6%
agneby-tiassa-me	2389	4.4%
poro-tchologo-bagoue	2319	4.3%
gbokle-nawa-san	2266	4.2%
pedro	2266	4.2%
n'zi-ifou-moronou	2132	4.0%
belier	1625	3.0%
Other values (13)	13921	25.9%

Most occurring characters

Value	Count	Frequency (%)
A	60152	12.1%
O	55720	11.2%
N	43342	8.7%
-	32822	6.6%
B	27613	5.6%
I	25728	5.2%
D	24835	5.0%
G	22926	4.6%
E	22869	4.6%
S	21614	4.4%
Other values (19)	159037	32.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	432639	87.1%
Dash Punctuation	32822	6.6%
Space Separator	17964	3.6%
Decimal Number	11101	2.2%
Other Punctuation	2132	0.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	60152	13.9%
O	55720	12.9%
N	43342	10.0%
B	27613	6.4%
I	25728	5.9%
D	24835	5.7%
G	22926	5.3%
E	22869	5.3%
S	21614	5.0%
U	20135	4.7%
Other values (14)	107705	24.9%

Decimal Number

Value	Count	Frequency (%)
2	6504	58.6%
1	4597	41.4%

Dash Punctuation

Value	Count	Frequency (%)
-	32822	100.0%

Space Separator

Value	Count	Frequency (%)
	17964	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	2132	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	432639	87.1%
Common	64019	12.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	60152	13.9%
O	55720	12.9%
N	43342	10.0%
B	27613	6.4%
I	25728	5.9%
D	24835	5.7%
G	22926	5.3%
E	22869	5.3%
S	21614	5.0%
U	20135	4.7%
Other values (14)	107705	24.9%

Common

Value	Count	Frequency (%)
-	32822	51.3%
	17964	28.1%
2	6504	10.2%
1	4597	7.2%
'	2132	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	496658	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	60152	12.1%
O	55720	11.2%
N	43342	8.7%
-	32822	6.6%
B	27613	5.6%
I	25728	5.2%
D	24835	5.0%
G	22926	4.6%
E	22869	4.6%
S	21614	4.4%
Other values (19)	159037	32.0%

district
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	80
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

KOUMASSI-PORT BOUET-VRIDI	2315
COCODY-BINGERVILLE	2016
ADJAME-PLATEAU-ATTECOUBE	1616
YOPOUGON-OUEST-SONGON	1366
ABOBO-EST	1298
Other values (75)	27142

Length

Max length	25
Median length	19
Mean length	10.836629
Min length	3

Characters and Unicode

Total characters	387442
Distinct characters	27
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ABENGOUROU
2nd row	ABENGOUROU
3rd row	ABENGOUROU
4th row	ABENGOUROU
5th row	ABENGOUROU

Common Values

Value	Count	Frequency (%)
KOUMASSI-PORT BOUET-VRIDI	2315	6.5%
COCODY-BINGERVILLE	2016	5.6%
ADJAME-PLATEAU-ATTECOUBE	1616	4.5%
YOPOUGON-OUEST-SONGON	1366	3.8%
ABOBO-EST	1298	3.6%
SOUBRE	1058	3.0%
TANDA	937	2.6%
TIASSALE	845	2.4%
YOPOUGON-EST	800	2.2%
GAGNOA	800	2.2%
Other values (70)	22702	63.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
koumassi-port	2315	6.0%
bouet-vridi	2315	6.0%
cocody-bingerville	2016	5.2%
adjame-plateau-attecoube	1616	4.2%
yopougon-ouest-songon	1366	3.5%
abobo-est	1298	3.4%
soubre	1058	2.7%
tanda	937	2.4%
tiassale	845	2.2%
gagnoa	800	2.1%
Other values (73)	23970	62.2%

Most occurring characters

Value	Count	Frequency (%)
O	53186	13.7%
A	41404	10.7%
E	30982	8.0%
U	28152	7.3%
I	24107	6.2%
S	20980	5.4%
N	20414	5.3%
T	18688	4.8%
B	17292	4.5%
-	16780	4.3%
Other values (17)	115457	29.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	367594	94.9%
Dash Punctuation	16780	4.3%
Space Separator	2783	0.7%
Other Punctuation	285	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	53186	14.5%
A	41404	11.3%
E	30982	8.4%
U	28152	7.7%
I	24107	6.6%
S	20980	5.7%
N	20414	5.6%
T	18688	5.1%
B	17292	4.7%
R	15822	4.3%
Other values (14)	96567	26.3%

Dash Punctuation

Value	Count	Frequency (%)
-	16780	100.0%

Space Separator

Value	Count	Frequency (%)
	2783	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	285	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	367594	94.9%
Common	19848	5.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	53186	14.5%
A	41404	11.3%
E	30982	8.4%
U	28152	7.7%
I	24107	6.6%
S	20980	5.7%
N	20414	5.6%
T	18688	5.1%
B	17292	4.7%
R	15822	4.3%
Other values (14)	96567	26.3%

Common

Value	Count	Frequency (%)
-	16780	84.5%
	2783	14.0%
'	285	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	387442	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	53186	13.7%
A	41404	10.7%
E	30982	8.0%
U	28152	7.3%
I	24107	6.2%
S	20980	5.4%
N	20414	5.3%
T	18688	4.8%
B	17292	4.5%
-	16780	4.3%
Other values (17)	115457	29.8%

site_code
Categorical

Distinct	155
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

C1015	416
C1087	413
C1030	405
C1055	404
C1112	398
Other values (150)	33717

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	178765
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C4001
2nd row	C4001
3rd row	C4001
4th row	C4001
5th row	C4001

Common Values

Value	Count	Frequency (%)
C1015	416	1.2%
C1087	413	1.2%
C1030	405	1.1%
C1055	404	1.1%
C1112	398	1.1%
C1077	392	1.1%
C1090	385	1.1%
C5063	381	1.1%
C2011	373	1.0%
C1027	366	1.0%
Other values (145)	31820	89.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c1015	416	1.2%
c1087	413	1.2%
c1030	405	1.1%
c1055	404	1.1%
c1112	398	1.1%
c1077	392	1.1%
c1090	385	1.1%
c5063	381	1.1%
c2011	373	1.0%
c1027	366	1.0%
Other values (145)	31820	89.0%

Most occurring characters

Value	Count	Frequency (%)
0	41361	23.1%
C	35753	20.0%
1	29393	16.4%
2	18278	10.2%
5	10153	5.7%
4	9087	5.1%
6	9066	5.1%
3	8344	4.7%
7	6348	3.6%
8	5750	3.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	143012	80.0%
Uppercase Letter	35753	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	41361	28.9%
1	29393	20.6%
2	18278	12.8%
5	10153	7.1%
4	9087	6.4%
6	9066	6.3%
3	8344	5.8%
7	6348	4.4%
8	5750	4.0%
9	5232	3.7%

Uppercase Letter

Value	Count	Frequency (%)
C	35753	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	143012	80.0%
Latin	35753	20.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	41361	28.9%
1	29393	20.6%
2	18278	12.8%
5	10153	7.1%
4	9087	6.4%
6	9066	6.3%
3	8344	5.8%
7	6348	4.4%
8	5750	4.0%
9	5232	3.7%

Latin

Value	Count	Frequency (%)
C	35753	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	178765	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	41361	23.1%
C	35753	20.0%
1	29393	16.4%
2	18278	10.2%
5	10153	5.7%
4	9087	5.1%
6	9066	5.1%
3	8344	4.7%
7	6348	3.6%
8	5750	3.2%

product_code
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.5 MiB

AS27133	5368
AS27000	5259
AS27134	4708
AS27137	4449
AS27132	4436
Other values (6)	11533

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	250271
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AS27134
2nd row	AS27132
3rd row	AS27000
4th row	AS27137
5th row	AS27138

Common Values

Value	Count	Frequency (%)
AS27133	5368	15.0%
AS27000	5259	14.7%
AS27134	4708	13.2%
AS27137	4449	12.4%
AS27132	4436	12.4%
AS27138	4060	11.4%
AS27139	2347	6.6%
AS46000	1981	5.5%
AS42018	1550	4.3%
AS17005	1248	3.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
as27133	5368	15.0%
as27000	5259	14.7%
as27134	4708	13.2%
as27137	4449	12.4%
as27132	4436	12.4%
as27138	4060	11.4%
as27139	2347	6.6%
as46000	1981	5.5%
as42018	1550	4.3%
as17005	1248	3.5%

Most occurring characters

Value	Count	Frequency (%)
2	37307	14.9%
7	36324	14.5%
A	35753	14.3%
S	35753	14.3%
3	30736	12.3%
1	28860	11.5%
0	25766	10.3%
4	8239	3.3%
8	5610	2.2%
9	2347	0.9%
Other values (2)	3576	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	178765	71.4%
Uppercase Letter	71506	28.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	37307	20.9%
7	36324	20.3%
3	30736	17.2%
1	28860	16.1%
0	25766	14.4%
4	8239	4.6%
8	5610	3.1%
9	2347	1.3%
6	2328	1.3%
5	1248	0.7%

Uppercase Letter

Value	Count	Frequency (%)
A	35753	50.0%
S	35753	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	178765	71.4%
Latin	71506	28.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	37307	20.9%
7	36324	20.3%
3	30736	17.2%
1	28860	16.1%
0	25766	14.4%
4	8239	4.6%
8	5610	3.1%
9	2347	1.3%
6	2328	1.3%
5	1248	0.7%

Latin

Value	Count	Frequency (%)
A	35753	50.0%
S	35753	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	250271	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	37307	14.9%
7	36324	14.5%
A	35753	14.3%
S	35753	14.3%
3	30736	12.3%
1	28860	11.5%
0	25766	10.3%
4	8239	3.3%
8	5610	2.2%
9	2347	0.9%
Other values (2)	3576	1.4%

stock_initial
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	798
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.245518

Minimum	0
Maximum	4320
Zeros	12431
Zeros (%)	34.8%
Negative	0
Negative (%)	0.0%
Memory size	558.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	12
Q3	69
95-th percentile	252
Maximum	4320
Range	4320
Interquartile range (IQR)	69

Descriptive statistics

Standard deviation	168.66154
Coefficient of variation (CV)	2.6667746
Kurtosis	140.02872
Mean	63.245518
Median Absolute Deviation (MAD)	12
Skewness	9.4428505
Sum	2261217
Variance	28446.715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12431	34.8%
10	957	2.7%
1	829	2.3%
100	696	1.9%
2	648	1.8%
20	615	1.7%
30	546	1.5%
50	514	1.4%
3	489	1.4%
5	463	1.3%
Other values (788)	17565	49.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12431	34.8%
1	829	2.3%
2	648	1.8%
3	489	1.4%
4	381	1.1%
5	463	1.3%
6	327	0.9%
7	325	0.9%
8	364	1.0%
9	387	1.1%

Value	Count	Frequency (%)
4320	5	< 0.1%
3428	1	< 0.1%
3061	1	< 0.1%
3039	1	< 0.1%
3024	1	< 0.1%
3015	1	< 0.1%
2709	1	< 0.1%
2691	2	< 0.1%
2632	1	< 0.1%
2592	21	0.1%

stock_received
Real number (ℝ)

Distinct	259
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.846055

Minimum	0
Maximum	3534
Zeros	29360
Zeros (%)	82.1%
Negative	0
Negative (%)	0.0%
Memory size	558.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	100
Maximum	3534
Range	3534
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	70.631782
Coefficient of variation (CV)	4.7576129
Kurtosis	451.68429
Mean	14.846055
Median Absolute Deviation (MAD)	0
Skewness	15.620155
Sum	530791
Variance	4988.8487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	29360	82.1%
100	962	2.7%
10	728	2.0%
50	557	1.6%
20	484	1.4%
30	384	1.1%
25	269	0.8%
200	250	0.7%
1	170	0.5%
5	158	0.4%
Other values (249)	2431	6.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29360	82.1%
1	170	0.5%
2	128	0.4%
3	97	0.3%
4	74	0.2%
5	158	0.4%
6	52	0.1%
7	56	0.2%
8	16	< 0.1%
9	42	0.1%

Value	Count	Frequency (%)
3534	1	< 0.1%
3024	1	< 0.1%
2500	1	< 0.1%
2160	1	< 0.1%
1824	1	< 0.1%
1800	2	< 0.1%
1623	1	< 0.1%
1550	1	< 0.1%
1536	1	< 0.1%
1500	1	< 0.1%

stock_distributed
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	338
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.764327

Minimum	0
Maximum	1728
Zeros	17738
Zeros (%)	49.6%
Negative	0
Negative (%)	0.0%
Memory size	558.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	13
95-th percentile	71
Maximum	1728
Range	1728
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	39.848242
Coefficient of variation (CV)	2.6989541
Kurtosis	214.36183
Mean	14.764327
Median Absolute Deviation (MAD)	1
Skewness	9.8685132
Sum	527869
Variance	1587.8824
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	17738	49.6%
1	1388	3.9%
2	1088	3.0%
10	1023	2.9%
3	976	2.7%
5	820	2.3%
4	693	1.9%
6	657	1.8%
7	538	1.5%
20	505	1.4%
Other values (328)	10327	28.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17738	49.6%
1	1388	3.9%
2	1088	3.0%
3	976	2.7%
4	693	1.9%
5	820	2.3%
6	657	1.8%
7	538	1.5%
8	461	1.3%
9	485	1.4%

Value	Count	Frequency (%)
1728	1	< 0.1%
1183	1	< 0.1%
1085	1	< 0.1%
1008	1	< 0.1%
1000	1	< 0.1%
960	1	< 0.1%
880	1	< 0.1%
864	1	< 0.1%
800	1	< 0.1%
720	1	< 0.1%

stock_adjustment
Real number (ℝ)

SKEWED ZEROS

Distinct	389
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.96115011

Minimum	-1440
Maximum	3003
Zeros	34013
Zeros (%)	95.1%
Negative	585
Negative (%)	1.6%
Memory size	558.6 KiB

Quantile statistics

Minimum	-1440
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	3003
Range	4443
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	37.883099
Coefficient of variation (CV)	39.414342
Kurtosis	2008.8713
Mean	0.96115011
Median Absolute Deviation (MAD)	0
Skewness	23.376255
Sum	34364
Variance	1435.1292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	34013	95.1%
10	87	0.2%
1	62	0.2%
2	51	0.1%
20	51	0.1%
-1	49	0.1%
25	43	0.1%
100	42	0.1%
50	41	0.1%
3	40	0.1%
Other values (379)	1274	3.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1440	2	< 0.1%
-817	1	< 0.1%
-747	1	< 0.1%
-720	1	< 0.1%
-696	1	< 0.1%
-661	1	< 0.1%
-600	1	< 0.1%
-588	1	< 0.1%
-576	1	< 0.1%
-510	1	< 0.1%

Value	Count	Frequency (%)
3003	1	< 0.1%
2574	1	< 0.1%
1440	1	< 0.1%
1287	1	< 0.1%
1085	1	< 0.1%
894	1	< 0.1%
852	1	< 0.1%
818	1	< 0.1%
673	1	< 0.1%
600	1	< 0.1%

stock_end
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	804
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.288395

Minimum	0
Maximum	4320
Zeros	11976
Zeros (%)	33.5%
Negative	0
Negative (%)	0.0%
Memory size	558.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	13
Q3	70
95-th percentile	254
Maximum	4320
Range	4320
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	170.84848
Coefficient of variation (CV)	2.6575322
Kurtosis	137.74798
Mean	64.288395
Median Absolute Deviation (MAD)	13
Skewness	9.4180673
Sum	2298503
Variance	29189.203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11976	33.5%
10	977	2.7%
1	833	2.3%
100	694	1.9%
2	652	1.8%
20	626	1.8%
30	552	1.5%
50	526	1.5%
3	500	1.4%
5	486	1.4%
Other values (794)	17931	50.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11976	33.5%
1	833	2.3%
2	652	1.8%
3	500	1.4%
4	388	1.1%
5	486	1.4%
6	335	0.9%
7	337	0.9%
8	372	1.0%
9	396	1.1%

Value	Count	Frequency (%)
4320	5	< 0.1%
3428	1	< 0.1%
3061	1	< 0.1%
3039	1	< 0.1%
3024	1	< 0.1%
3015	1	< 0.1%
3000	1	< 0.1%
2709	1	< 0.1%
2691	2	< 0.1%
2632	1	< 0.1%

average_monthly_consumption
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	313
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.606439

Minimum	0
Maximum	864
Zeros	13191
Zeros (%)	36.9%
Negative	0
Negative (%)	0.0%
Memory size	558.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	16
95-th percentile	65
Maximum	864
Range	864
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	32.521384
Coefficient of variation (CV)	2.2265101
Kurtosis	68.435678
Mean	14.606439
Median Absolute Deviation (MAD)	3
Skewness	6.2185845
Sum	522224
Variance	1057.6404
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13191	36.9%
1	1999	5.6%
3	1767	4.9%
2	1567	4.4%
7	1078	3.0%
4	1003	2.8%
8	928	2.6%
5	903	2.5%
10	761	2.1%
6	749	2.1%
Other values (303)	11807	33.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13191	36.9%
1	1999	5.6%
2	1567	4.4%
3	1767	4.9%
4	1003	2.8%
5	903	2.5%
6	749	2.1%
7	1078	3.0%
8	928	2.6%
9	602	1.7%

Value	Count	Frequency (%)
864	1	< 0.1%
816	1	< 0.1%
624	1	< 0.1%
600	1	< 0.1%
567	2	< 0.1%
496	1	< 0.1%
467	1	< 0.1%
456	1	< 0.1%
432	1	< 0.1%
400	2	< 0.1%

stock_ordered
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	333
Distinct (%)	1.0%
Missing	763
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	26.658102

Minimum	0
Maximum	10240
Zeros	21552
Zeros (%)	60.3%
Negative	0
Negative (%)	0.0%
Memory size	558.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	20
95-th percentile	120
Maximum	10240
Range	10240
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	107.16608
Coefficient of variation (CV)	4.0200192
Kurtosis	2976.5893
Mean	26.658102
Median Absolute Deviation (MAD)	0
Skewness	39.966619
Sum	932767
Variance	11484.569
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21552	60.3%
100	1765	4.9%
10	1729	4.8%
50	1319	3.7%
20	1139	3.2%
30	869	2.4%
200	498	1.4%
5	437	1.2%
1	421	1.2%
25	404	1.1%
Other values (323)	4857	13.6%
(Missing)	763	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21552	60.3%
1	421	1.2%
2	322	0.9%
3	259	0.7%
4	159	0.4%
5	437	1.2%
6	178	0.5%
7	49	0.1%
8	82	0.2%
9	79	0.2%

Value	Count	Frequency (%)
10240	1	< 0.1%
6000	1	< 0.1%
5000	2	< 0.1%
3000	2	< 0.1%
2525	1	< 0.1%
2448	1	< 0.1%
2000	5	< 0.1%
1600	2	< 0.1%
1550	1	< 0.1%
1500	2	< 0.1%

site_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Hospital	24779
Health Center	10332
University Hospital/National Institute	642

Length

Max length	38
Median length	8
Mean length	9.9836098
Min length	8

Characters and Unicode

Total characters	356944
Distinct characters	21
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hospital
2nd row	Hospital
3rd row	Hospital
4th row	Hospital
5th row	Hospital

Common Values

Value	Count	Frequency (%)
Hospital	24779	69.3%
Health Center	10332	28.9%
University Hospital/National Institute	642	1.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hospital	24779	52.3%
health	10332	21.8%
center	10332	21.8%
university	642	1.4%
hospital/national	642	1.4%
institute	642	1.4%

Most occurring characters

Value	Count	Frequency (%)
t	49295	13.8%
a	37037	10.4%
l	36395	10.2%
H	35753	10.0%
e	32280	9.0%
i	27989	7.8%
s	26705	7.5%
o	26063	7.3%
p	25421	7.1%
n	12258	3.4%
Other values (11)	47748	13.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	296675	83.1%
Uppercase Letter	48011	13.5%
Space Separator	11616	3.3%
Other Punctuation	642	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	49295	16.6%
a	37037	12.5%
l	36395	12.3%
e	32280	10.9%
i	27989	9.4%
s	26705	9.0%
o	26063	8.8%
p	25421	8.6%
n	12258	4.1%
r	10974	3.7%
Other values (4)	12258	4.1%

Uppercase Letter

Value	Count	Frequency (%)
H	35753	74.5%
C	10332	21.5%
U	642	1.3%
N	642	1.3%
I	642	1.3%

Space Separator

Value	Count	Frequency (%)
	11616	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	642	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	344686	96.6%
Common	12258	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	49295	14.3%
a	37037	10.7%
l	36395	10.6%
H	35753	10.4%
e	32280	9.4%
i	27989	8.1%
s	26705	7.7%
o	26063	7.6%
p	25421	7.4%
n	12258	3.6%
Other values (9)	35490	10.3%

Common

Value	Count	Frequency (%)
	11616	94.8%
/	642	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356944	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	49295	13.8%
a	37037	10.4%
l	36395	10.2%
H	35753	10.0%
e	32280	9.0%
i	27989	7.8%
s	26705	7.5%
o	26063	7.3%
p	25421	7.1%
n	12258	3.4%
Other values (11)	47748	13.4%

Auto

Heatmap
Table

	month	stock_initial	stock_received	stock_distributed	stock_adjustment	stock_end	average_monthly_consumption	stock_ordered	year	region	district	product_code	site_type
month	1.000	0.038	0.029	0.014	-0.023	0.036	0.008	-0.032	0.234	0.000	0.000	0.030	0.011
stock_initial	0.038	1.000	-0.042	0.586	-0.083	0.808	0.579	-0.103	0.021	0.053	0.120	0.069	0.026
stock_received	0.029	-0.042	1.000	0.282	-0.001	0.300	0.294	0.057	0.006	0.013	0.025	0.026	0.000
stock_distributed	0.014	0.586	0.282	1.000	0.056	0.490	0.809	0.248	0.016	0.034	0.080	0.044	0.000
stock_adjustment	-0.023	-0.083	-0.001	0.056	1.000	0.086	0.052	-0.006	0.019	0.009	0.030	0.022	0.023
stock_end	0.036	0.808	0.300	0.490	0.086	1.000	0.527	-0.235	0.020	0.053	0.120	0.070	0.027
average_monthly_consumption	0.008	0.579	0.294	0.809	0.052	0.527	1.000	0.274	0.018	0.053	0.122	0.068	0.009
stock_ordered	-0.032	-0.103	0.057	0.248	-0.006	-0.235	0.274	1.000	0.011	0.029	0.065	0.020	0.000
year	0.234	0.021	0.006	0.016	0.019	0.020	0.018	0.011	1.000	0.055	0.099	0.122	0.055
region	0.000	0.053	0.013	0.034	0.009	0.053	0.053	0.029	0.055	1.000	0.999	0.071	0.560
district	0.000	0.120	0.025	0.080	0.030	0.120	0.122	0.065	0.099	0.999	1.000	0.130	0.735
product_code	0.030	0.069	0.026	0.044	0.022	0.070	0.068	0.020	0.122	0.071	0.130	1.000	0.051
site_type	0.011	0.026	0.000	0.000	0.023	0.027	0.009	0.000	0.055	0.560	0.735	0.051	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	year	month	region	district	site_code	product_code	stock_initial	stock_received	stock_distributed	stock_adjustment	stock_end	average_monthly_consumption	stock_ordered	site_type
0	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27134	75	0	21	-54	0	18	100.0	Hospital
1	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27132	3	0	3	0	0	2	10.0	Hospital
2	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27000	0	75	22	0	53	9	0.0	Hospital
3	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27137	2	0	0	0	2	0	0.0	Hospital
4	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27138	45	0	2	0	43	1	0.0	Hospital
5	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27133	50	50	19	0	81	6	0.0	Hospital
6	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4023	AS27000	40	0	0	0	40	10	0.0	Health Center
7	2019	1	INDENIE-DJUABLIN	ABENGOUROU	C4023	AS27133	150	0	29	0	121	51	0.0	Health Center
8	2019	2	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27134	0	0	0	0	0	18	100.0	Hospital
9	2019	2	INDENIE-DJUABLIN	ABENGOUROU	C4001	AS27132	0	0	0	0	0	2	10.0	Hospital

	year	month	region	district	site_code	product_code	stock_initial	stock_received	stock_distributed	stock_end	average_monthly_consumption	stock_ordered	site_type
35743	2016	10	LOH-DJIBOUA	GUITRY	C2055	AS27134	0	100	9	91	3	0.0	Hospital
35744	2016	10	LOH-DJIBOUA	GUITRY	C2055	AS17005	46	0	0	46	0	0.0	Hospital
35745	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS27137	13	0	5	8	3	0.0	Hospital
35746	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS27139	0	0	0	0	0	100.0	Hospital
35747	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS27000	18	10	15	13	16	10.0	Hospital
35748	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS27133	0	50	25	25	8	25.0	Hospital
35749	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS27138	150	0	0	150	0	0.0	Hospital
35750	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS27132	1	10	4	7	13	0.0	Hospital
35751	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS27134	8	0	8	0	10	0.0	Hospital
35752	2016	7	LOH-DJIBOUA	GUITRY	C2055	AS17005	48	0	2	46	1	0.0	Hospital

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters